GREATER

The GREATER field specifier (case sensitive) allows you to find documents in which a specified field contains a number that is greater than a specified number.

NOTE: You can optimize the field specifier speed by restricting the field to the NumericType property type.

Format

FieldText=GREATER{yourNumber}:yourFields
yourNumber

A number. A document returns only if one of yourFields contains a number that is greater than this number.

By default, the range is exclusive. You can add an equals sign (=) to include the number that you specify.
yourFields One or more fields. A document returns only if it contains one of these fields, and if the number in this field is greater than yourNumber. Separate multiple fields with colons (:). There must be no space before or after a colon.

Example

FieldText=GREATER{66}:ID

The ID field must contain a number greater than 66 for the document to return.

FieldText=GREATER{5.59}:PRICE:PREIS

The PRICE or PREIS field must contain a number greater than 5.59 for the document to return.

FieldText=GREATER{=6}:QUANTITY

The QUANTITY field must contain a value of 6 or greater for the document to return.